| Query: | SELECT COUNT(`T1`.`price`) AS `Number` , SUBSTRING_INDEX(`T1`.`price`, '|', 1) AS `price` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND `T1`.`Sub_status` <> 'invisible' AND `T3`.`Type` = 'listings' AND `T1`.`price` <> '' AND `T1`.`price` <> '0' AND `T1`.`booking_module` = '1' AND `T1`.`sale_rent` = '2' AND `T1`.`time_frame` = '2' AND `T1`.`bagni_testo` = 'Animali domestici ammessi' AND `T1`.`amimali_domestici` = 'Sauna' AND `T1`.`locaton` = 'Silvaplana, Oberengadin' GROUP BY SUBSTRING_INDEX(`T1`.`price`, '|', 1) HAVING COUNT(`T1`.`price`) > 0 ORDER BY `Number` DESC |
